Jassif Team Institution

उत्पाद तालिका

+-----------+----------------+------------+-------+
| ProductID | ProductName    | CategoryID | Price |
+-----------+----------------+------------+-------+
| 1         | Chais          | 1          | 18    |
| 2         | Chang          | 1          | 19    |
| 3         | Aniseed Syrup  | 2          | 10    |
+-----------+----------------+------------+-------+

श्रेणियाँ तालिका

+------------+----------------+----------------------------------------------------+
| CategoryID | CategoryName   | Description                                        |
+------------+----------------+----------------------------------------------------+
| 1          | Beverages      | Soft drinks, coffees, teas, beers, and ales        |
| 2          | Condiments     | Sweet and savory sauces, relishes, spreads, etc.   |
| 3          | Confections    | Desserts, candies, and sweet breads                |
+------------+----------------+----------------------------------------------------+

उदाहरण

INNER JOIN कीवर्ड का उपयोग करके उत्पादों और श्रेणियों से जुड़ें:

SELECT ProductID, ProductName, CategoryName
FROM Products
INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID;

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;

उदाहरण

तालिका नाम निर्दिष्ट करें:

SELECT Products.ProductID, Products.ProductName, Categories.CategoryName
FROM Products
INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID;

उदाहरण

जॉइन इनर जॉइन के बराबर है:

SELECT Products.ProductID, Products.ProductName, Categories.CategoryName
FROM Products
JOIN Categories ON Products.CategoryID = Categories.CategoryID;

शिपर्स शेड्यूल

+-----------+-------------------+------------------+
| ShipperID | ShipperName       | Phone            |
+-----------+-------------------+------------------+
| 1         | Speedy Express    | (503) 555-9831   |
| 2         | United Package    | (503) 555-3199   |
| 3         | Federal Shipping  | (503) 555-9931   |
+-----------+-------------------+------------------+

उदाहरण

SELECT Orders.OrderID, Customers.CustomerName, Shippers.ShipperName
FROM ((Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID)
INNER JOIN Shippers ON Orders.ShipperID = Shippers.ShipperID);